use YongTest
go
create schema HumanResoueces
go

CREATE TABLE HumanResoueces.Employee (EmpID int IDENTITY(1,1), FirstName varchar(20), LastName varchar(20))

insert into HumanResoueces.Employee 
output inserted.* into  HumanResoueces.Employee2
values ('yong', 'choi') ;


insert HumanResoueces.Employee 
output inserted.* into  HumanResoueces.Employee2
values('nathan', 'choi');

insert into HumanResoueces.Employee (FirstName, LastName) 
output inserted.* into  HumanResoueces.Employee2
values ('kiye', 'Kim'), ('jinu','choi')

CREATE TABLE HumanResoueces.Employee2 (EmpID int, FirstName varchar(20), LastName varchar(20))

delete from HumanResoueces.Employee
Output deleted.* into HumanResoueces.Employee2


select * from HumanResoueces.Employee2